Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ReportingClassificationCode (PK) | A code used to classify the monetary values, unit counts and quantities that are accumulated in the CustomerAccountLedger and CustomerAccountJournal. The range of values varies depending on the CustomerAccountType and varieites of financial, non-finanicl unit counts and other quantities tracked by a retailer. Some samples include SALES $'s and units RETURN $;s and units TRANSACTION_COUNTs etc. It is up to each retailer to design its ledger categories for reporting and analyizing its business. | CD_RP_CLSFN | Code | varchar(20) | |
CustomerAccountTypeCode (FK)(PK) | Determines what kind of customer account this is. Examples include a trade account, a school account, a not-for-profit, regular customer, etc. LOYALTY - customer loyalty account for tracking points earned/redeemed REBATE -Customer reward account that pays customers based on cumulative net purchases over a deisgnated period of time TRADE - customer business credit account CONSUMER_CHG - customer individual consumer credit extended by retailer INSTALLMENT - credit account set up for one time purchase LAYAWAY - cash time payment account (not credit) RENTAL - customer rental for videos, equipment WORKORDER - account for handling services like installation and set up BACKORDER - account for handling backorder deposit and adjustments. | TY_CTAC | Code | varchar(20) | CustomerAccountType(CO_CT_ACNT_TYP) |
Name | The business name used in reporting for the CustomerLedgerReportingClassification. | NM_RP_CLSFN | Name | varchar(40) | |
CustomerAccountValuationUnitTypeCode (FK) | A code that identifies a kind of valuation unit. Examples include: MONEY POINTS MILES GALLONS VISITS others that are relevant to a retailer | CD_CT_ACNT_VLN_UN_TYP | Code | varchar(20) | CustomerAccountValuationUnitType(CO_CT_ACNT_VLN_UN_TYP) |
AccumulationTimeHorizonCode | Determines if this reporting classification is a LIFETIME accumulation or a REPORTING PERIOD accumulation. Reporting period accumulations are transferrred to history and zeroed out at period end. Lifetime accumulations are not zeroed out at the end of a reporting period. The intent of this code is to enable retailers to maintin lifetime customer balances for promotional program execution purposes (as opposed to pure analytics) | CD_ACCMLTN_TM_HRZN | Code | varchar(20) | |